package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "c_device_rec", simpleName = "", engine = MysqlDriver.InnoDB, comment = "设备入库记录")
public class _DDL_CDeviceRec {

    @_DDL_Primary()
    @_DDL_Column(name = "id", type = SqlType.INT, nullable = false, autoIncrement = true, comment = "入库id")
    private Integer id;

    @_DDL_Index(name = "IDX_c_device_rec_ag_id")
    @_DDL_Column(name = "ag_id", type = SqlType.INT_UNSIGNED, comment = "渠道商id")
    private Long agId;

    @_DDL_Index(name = "IDX_c_device_rec_type")
    @_DDL_Column(name = "type", type = SqlType.VARCHAR, size = 100, comment = "设备型号")
    private String type;

    @_DDL_Column(name = "count", type = SqlType.INT_UNSIGNED, comment = "入库")
    private Long count;

    @_DDL_Column(name = "func", type = SqlType.TINYINT_UNSIGNED, comment = "操作类型 0:入库 1:出库")
    private Integer func;

    @_DDL_Column(name = "cr_time", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP, comment = "创建时间")
    private java.sql.Timestamp crTime;

}
